Our client is looking for a Sr.Financial Business Analyst (FP&A,Hyperion,SQL).
The purpose of this position is to oversee FP&A reporting platforms and address techno functional support activities within the Global Corporate Finance IT Group. If interested, kindly reply back with your updated resume and contact info.
Sr.Financial Business Analyst (FP&A,Hyperion,SQL)
LOCATION: Jersey City (Onsite in a Hybrid role 2-3 onsite Mandatory)
6 MONTHS CONTRACT TO HIRE
The resource must also possess the aptitude to learn newly introduced Financial ERP Cloud applications and ancillary Finance platforms Employee must be a strategic thinker and demonstrate leadership elements and considerable independent judgment and initiative in carrying out project objectives Position will work in partnership with the Business to document, design changes, test, validate, and schedule application changes. The resource must have
- Dimensional Reporting Knowledge, with the ability to develop complex SQL scripts and stored procedures with Hyperion, Essbase, Smart View, web forms and reports
- Employees in this classification are responsible for managing and/or assisting in all techno functional support aspects of FP&A applications (with ERP/GL experience)
- Experience with financial statements, including income statements, balance sheet, P&I, and cash flow.
- The resource will be required to manage a small team of associates for various assignments
Qualifications
- 8-10 years Hands on experience with Hyperion/Essbase implementation, development, and support experience, preferably gained within one or more financial institution.
- Preferred knowledge in both Oracle Database Schema and Snow-Flake Schema data modeling techniques
- Create and maintain data forms, calculation scripts, MAXI automation, schedule jobs using batch scripts and business rules
- Develop and maintain Block Storage Outline/Aggregate Storage Outline (BSO/ASO) cubes Knowledge of Reporting Tools Hyperion BI+ (Web Analysis) Hyperion Reports 7.x/9.x,
- Hyperion Analyzer 7.x, Hyperion Excel Add-in, Smart View. SQL Loader functionality to interact with Essbase Cubes to and from with Oracle Database
Experience with this combination of software:
- Oracle Enterprise Performance Management System Workspace
- Hyperion Essbase
- Hyperion Planning Hyperion Shared Services
- Essbase
- Essbase integration Services:
- Excel Add-Ins
- Hyperion Financial Reporting Studio
- Interactive Reporting Studio
- Dashboard Reporting
- Saas Reporting Tools
We are an equal opportunity employer